<style type="text/css">
.paginate a{
	font-family:Arial, Helvetica, sans-serif;
	padding: 3px;
	margin: 0 auto;
	color: #000;
	text-align:center;
}
.paginate a:LINK {
	padding:2px 5px 2px 5px;
	margin:2px;
	border:1px solid #999;
	border-radius:3px;
	text-decoration:none;
	color: #000;
}
.paginate a:HOVER {
	border: 1px solid #000;
	color: #000;
}
.paginate a:visited {
	padding:2px 5px 2px 5px;
	margin:2px;
	border:1px solid #999;
	border-radius:3px;
	text-decoration:none;
	color: #000;
}
.disabled_pg1{
	border:1px solid #999;
	border-radius:3px;
	padding:2px 5px 2px 5px;
}
.disabled_pg2{
	border:1px solid #999;
	border-radius:3px;
	padding:2px 5px 2px 5px;
}
</style>
<?php
$query = "SELECT COUNT(*) as num FROM $tableName $ordem";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
	$start = ($page - 1) * $limit;
}else{
	$start = 0;
}
// Get page data
$query1 = "SELECT * FROM $tableName $ordem LIMIT $start, $limit";
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){
	$page = 1;
}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage - 1;

$paginate = '';
if($lastpage > 1){
	$paginate .= "<div class='paginate'>";
	// Previous
	if ($page > 1){
		$paginate.= "<a href='$targetpage?page=$prev&cmd=".$_REQUEST['cmd']."'>Anterior</a>";
	}else{
		$paginate.= "<span class='disabled_pg2'>Anterior</span>";
	}
	// Pages
	if($lastpage < 7 + ($stages * 2)){
		// Not enough pages to breaking it up
		for($counter = 1; $counter <= $lastpage; $counter++){
			if($counter == $page){
				$paginate.= "<span class='current_pg2'> $counter </span>";
			}else{
				$paginate.= "<a href='$targetpage?page=$counter&cmd=".$_REQUEST['cmd']."'>$counter</a>";
			}
		}
		}
		elseif($lastpage > 5 + ($stages * 2)){
		// Enough pages to hide a few?
		// Beginning only hide later pages
		if($page < 1 + ($stages * 2)){
		for ($counter = 1; $counter < 4 + ($stages * 2); $counter++){
		if($counter == $page){
		$paginate.= "<span class='current_pg2'> $counter </span>";
					}else{
		$paginate.= "<a href='$targetpage?page=$counter&cmd=".$_REQUEST['cmd']."'>$counter</a>";
		}
				}
		$paginate.= "...";
		$paginate.= "<a href='$targetpage?page=$LastPagem1&cmd=".$_REQUEST['cmd']."'>$LastPagem1</a>";
		$paginate.= "<a href='$targetpage?page=$lastpage&cmd=".$_REQUEST['cmd']."'>$lastpage</a>";
		}
		// Middle hide some front and some back
		elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2)){
		$paginate.= "<a href='$targetpage?page=1&cmd=".$_REQUEST['cmd']."'>1</a>";
		$paginate.= "<a href='$targetpage?page=2&cmd=".$_REQUEST['cmd']."'>2</a>";
		$paginate.= "...";
				for($counter = $page - $stages; $counter <= $page + $stages; $counter++){
		if($counter == $page){
		$paginate.= "<span class='current_pg2'> $counter </span>";
					}else{
						$paginate.= "<a href='$targetpage?page=$counter&cmd=".$_REQUEST['cmd']."'>$counter</a>";
		}
		}
				$paginate.= "...";
				$paginate.= "<a href='$targetpage?page=$LastPagem1&cmd=".$_REQUEST['cmd']."'>$LastPagem1</a>";
		$paginate.= "<a href='$targetpage?page=$lastpage&cmd=".$_REQUEST['cmd']."'>$lastpage</a>";
			}else{ // End only hide early pages
				$paginate.= "<a href='$targetpage?page=1&cmd=".$_REQUEST['cmd']."'>1</a>";
		$paginate.= "<a href='$targetpage?page=2&cmd=".$_REQUEST['cmd']."'>2</a>";
		$paginate.= "...";
		for($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++){
		if ($counter == $page){
		$paginate.= "<span class='current_pg2'> $counter </span>";
		}else{
		$paginate.= "<a href='$targetpage?page=$counter&cmd=".$_REQUEST['cmd']."'>$counter</a>";
		}
		}
		}
		}
		// Next
		if ($page < $counter - 1){
			$paginate.= "<a href='$targetpage?page=$next&cmd=".$_REQUEST['cmd']."'>Pr&oacute;ximo</a>";
}else{
			$paginate.= "<span class='disabled_pg2'>Pr&oacute;ximo</span>";
		}
		$paginate.= "</div>";
	}
?>